package com.arcbbs.mapper;

import com.arcbbs.entity.EmailCode;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface EmailCodeMapper {
    @Insert("insert into email_code (email,code,create_time,status) values (#{email},#{code},#{createTime},#{status})")
    void insert(EmailCode emailCode);

    void disablecode(String email);
@Select("select * from email_code where email=#{email} and code =#{emailCode}")
    EmailCode selectByEmailandCode(String email, String emailCode);
}
